SUPPORT / SAMPLES & SAS NOTES
Problem Note 46851: Errors occur when you perform tasks that require a reread of a DB2 table
 |  |  |  |  |
Errors are likely to occur when all of the following are attempted:
- A remote session to z/OS is created through SAS/CONNECT®
- A LIBNAME statement using SAS/ACCESS® Interface to DB2 and an RSUBMIT statement are submitted to the remote session
- In the local SAS session, a LIBNAME statement is allocated to the remote DB2 library via Remote Library Services (RLS)
- One of the DB2 tables is opened via VIEWTABLE
- Within VIEWTABLE, the mode is changed to Edit
- An observation from the DB2 table is deleted
- Within VIEWTABLE, the mode is changed back to Browse
When all of the above are performed, your SAS session might seem unresponsive or delayed, and the row(s) that you attempted to delete still exist in the DB2 table. Eventually, errors similar to those shown below appear in the SAS log. The only workaround is to not change the mode back to Browse before exiting out of VIEWTABLE.
REMOTE(S390DEVA): IEA995I SYMPTOM DUMP OUTPUT REMOTE(S390DEVA): SYSTEM COMPLETION CODE=04E REASON CODE=00E7000C REMOTE(S390DEVA): TIME=11.55.42 SEQ=39179 CPU=0080 ASID=0101 REMOTE(S390DEVA): PSW AT TIME OF ERROR 077C1001 A3C45166 ILC 2 INTC 0D ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [ViewTable Window] Exception occurred at (4B781335) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) 4B781335 0A9BBB64 tknlssb:tknlssb+0x335 6795AA7A 0A9BBBDC saswzx:tkvercn1+0x19A3A 6795A6F3 0A9BBC54 saswzx:tkvercn1+0x196B3 667A871B 0A9BBCC4 sasyoio:tkvercn1+0x76DB 667A4405 0A9BBDA4 sasyoio:tkvercn1+0x33C5 5C718ADA 0A9BBE54 sasgdat:tkvercn1+0x17A9A 5C701799 0A9BBFFC sasgdat:tkvercn1+0x759 571BA543 0A9BC040 saspos:tkvercn1+0x19503 571B52F1 0A9BC434 saspos:tkvercn1+0x142B1 571BFB4D 0A9BC4E8 saspos:tkvercn1+0x1EB0D 5C6A4DB8 0A9BC9C0 sasgfsv:tkvercn1+0x23D78 571BA543 0A9BCA04 saspos:tkvercn1+0x19503 571B52F1 0A9BCDF8 saspos:tkvercn1+0x142B1 571BFB4D 0A9BCEAC saspos:tkvercn1+0x1EB0D 0999E49B 0A9BD458 sasoted:tkvercn1+0xD45B 0999D661 0A9BD550 sasoted:tkvercn1+0xC621 099C5EDA 0A9BD6C8 sasoted:tkvercn1+0x34E9A 099C23E4 0A9BD71C sasoted:tkvercn1+0x313A4 09992D23 0A9BD73C sasoted:tkvercn1+0x1CE3 606FA131 0A9BD82C sasrm:tkvercn1+0x190F1 606F11B0 0A9BD8E8 sasrm:tkvercn1+0x10170 6071E860 0A9BD930 sasrm:tkvercn1+0x3D820 60716B06 0A9BD954 sasrm:tkvercn1+0x35AC6 60716AEC 0A9BD96C sasrm:tkvercn1+0x35AAC 65C3726B 0A9BDC44 sasabld:tkvercn1+0x622B 606E6034 0A9BDDDC sasrm:tkvercn1+0x4FF4 60712C40 0A9BDEE8 sasrm:tkvercn1+0x31C00 65AF212C 0A9BDF30 sasf03:tkvercn1+0x210EC 65BE8423 0A9BDF68 sasaf:tkvercn1+0x73E3 65BF0372 0A9BDFB8 sasaf:tkvercn1+0xF332 65BF06F1 0A9BE14C sasaf:tkvercn1+0xF6B1 570FC1C7 0A9BE49C saspxq:tkvercn1+0x2B187 570FBA75 0A9BE4B0 saspxq:tkvercn1+0x2AA35 570D6C54 0A9BE598 saspxq:tkvercn1+0x5C14 570DE6D7 0A9BE8E8 saspxq:tkvercn1+0xD697 570DA5A7 0A9BEB58 saspxq:tkvercn1+0x9567 65BE21B2 0A9BEE30 sasaf:tkvercn1+0x1172 65BE4480 0A9BF0A0 sasaf:tkvercn1+0x3440 65A71975 0A9BFF54 saszaf:tkvercn1+0x935 00B92DB4 0A9BFFA0 sashost:Main+0xCF84 00C86038 0A9BFFB4 sashost:Main+0x100208 7C80B713 0A9BFFEC kernel32:GetModuleFileNameA+0x1B4 REMOTE(S390DEVA): ACTIVE LOAD MODULE ADDRESS=99999999 OFFSET=0A2AB7CD REMOTE(S390DEVA): NAME=rrrrrrrr REMOTE(S390DEVA): DATA AT PSW IS UNAVAILABLE AT THIS TIME REMOTE(S390DEVA): GR 0: 00000000_80000000 1: 00000000_8004E000 REMOTE(S390DEVA): 2: 00000000_00000010 3: 00000048_B27FC894 REMOTE(S390DEVA): 4: 00000000_00000002 5: 00000000_00000080 REMOTE(S390DEVA): 6: 00000000_18996C48 7: 00000000_00000000 REMOTE(S390DEVA): 8: 00000000_22D3E4B0 9: 00000000_7A28D1F4 REMOTE(S390DEVA): A: 00000000_18996BA0 B: 00000000_18996BA0 REMOTE(S390DEVA): C: 00000000_23C4EFE0 D: 00000000_7A4AB938 REMOTE(S390DEVA): E: 00000000_7A747908 F: 00000000_00E7000C REMOTE(S390DEVA): END OF SYMPTOM DUMP ERROR: INTERNAL ERROR - YP UNABLE TO FORMAT MESSAGE. ERROR: Generic critical error.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to DB2 | z/OS | 9.2 TS2M3 | 9.4 TS1M0 |